Overview

Dataset statistics

Number of variables13
Number of observations2970
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory301.8 KiB
Average record size in memory104.0 B

Variable types

Numeric13

Alerts

gross_revenue is highly correlated with qtde_invoices and 3 other fieldsHigh correlation
recency_days is highly correlated with qtde_invoicesHigh correlation
qtde_invoices is highly correlated with gross_revenue and 3 other fieldsHigh correlation
qtde_items is highly correlated with gross_revenue and 3 other fieldsHigh correlation
qtde_products is highly correlated with gross_revenue and 3 other fieldsHigh correlation
avg_ticket is highly correlated with avg_unique_basket_sizeHigh correlation
avg_recency_days is highly correlated with frequencyHigh correlation
frequency is highly correlated with avg_recency_daysHigh correlation
avg_basket_size is highly correlated with gross_revenue and 1 other fieldsHigh correlation
avg_unique_basket_size is highly correlated with qtde_products and 1 other fieldsHigh correlation
gross_revenue is highly correlated with qtde_invoices and 1 other fieldsHigh correlation
qtde_invoices is highly correlated with gross_revenue and 2 other fieldsHigh correlation
qtde_items is highly correlated with gross_revenue and 1 other fieldsHigh correlation
qtde_products is highly correlated with qtde_invoicesHigh correlation
avg_ticket is highly correlated with qtde_returns and 1 other fieldsHigh correlation
qtde_returns is highly correlated with avg_ticket and 1 other fieldsHigh correlation
avg_basket_size is highly correlated with avg_ticket and 1 other fieldsHigh correlation
gross_revenue is highly correlated with qtde_invoices and 2 other fieldsHigh correlation
qtde_invoices is highly correlated with gross_revenue and 2 other fieldsHigh correlation
qtde_items is highly correlated with gross_revenue and 3 other fieldsHigh correlation
qtde_products is highly correlated with gross_revenue and 2 other fieldsHigh correlation
avg_recency_days is highly correlated with frequencyHigh correlation
frequency is highly correlated with avg_recency_daysHigh correlation
avg_basket_size is highly correlated with qtde_itemsHigh correlation
gross_revenue is highly correlated with qtde_invoices and 5 other fieldsHigh correlation
qtde_invoices is highly correlated with gross_revenue and 2 other fieldsHigh correlation
qtde_items is highly correlated with gross_revenue and 5 other fieldsHigh correlation
qtde_products is highly correlated with gross_revenue and 2 other fieldsHigh correlation
avg_ticket is highly correlated with gross_revenue and 3 other fieldsHigh correlation
qtde_returns is highly correlated with gross_revenue and 3 other fieldsHigh correlation
avg_basket_size is highly correlated with gross_revenue and 3 other fieldsHigh correlation
avg_ticket is highly skewed (γ1 = 53.45321988) Skewed
frequency is highly skewed (γ1 = 24.88439605) Skewed
qtde_returns is highly skewed (γ1 = 51.80645659) Skewed
avg_basket_size is highly skewed (γ1 = 44.68007213) Skewed
df_index has unique values Unique
customer_id has unique values Unique
recency_days has 34 (1.1%) zeros Zeros
qtde_returns has 1481 (49.9%) zeros Zeros

Reproduction

Analysis started2021-12-24 04:21:31.866298
Analysis finished2021-12-24 04:22:23.695573
Duration51.83 seconds
Software versionpandas-profiling v3.1.0
Download configurationconfig.json

Variables

df_index
Real number (ℝ≥0)

UNIQUE

Distinct2970
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2317.86532
Minimum0
Maximum5716
Zeros1
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2021-12-24T00:22:23.933670image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile185.45
Q1929.25
median2120.5
Q33537.75
95-th percentile5036.1
Maximum5716
Range5716
Interquartile range (IQR)2608.5

Descriptive statistics

Standard deviation1555.136615
Coefficient of variation (CV)0.6709348474
Kurtosis-1.010761417
Mean2317.86532
Median Absolute Deviation (MAD)1271
Skewness0.3420323534
Sum6884060
Variance2418449.89
MonotonicityStrictly increasing
2021-12-24T00:22:24.294079image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
01
 
< 0.1%
30111
 
< 0.1%
29961
 
< 0.1%
29991
 
< 0.1%
30001
 
< 0.1%
30011
 
< 0.1%
30021
 
< 0.1%
30051
 
< 0.1%
30071
 
< 0.1%
30081
 
< 0.1%
Other values (2960)2960
99.7%
ValueCountFrequency (%)
01
< 0.1%
11
< 0.1%
21
< 0.1%
31
< 0.1%
41
< 0.1%
51
< 0.1%
61
< 0.1%
71
< 0.1%
81
< 0.1%
91
< 0.1%
ValueCountFrequency (%)
57161
< 0.1%
56971
< 0.1%
56871
< 0.1%
56811
< 0.1%
56601
< 0.1%
56561
< 0.1%
56501
< 0.1%
56391
< 0.1%
56381
< 0.1%
56281
< 0.1%

customer_id
Real number (ℝ≥0)

UNIQUE

Distinct2970
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15270.71818
Minimum12347
Maximum18287
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2021-12-24T00:22:24.618601image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/

Quantile statistics

Minimum12347
5-th percentile12619.45
Q113799.75
median15220.5
Q316767.75
95-th percentile17964.55
Maximum18287
Range5940
Interquartile range (IQR)2968

Descriptive statistics

Standard deviation1718.703373
Coefficient of variation (CV)0.112548955
Kurtosis-1.205496241
Mean15270.71818
Median Absolute Deviation (MAD)1487
Skewness0.03170847426
Sum45354033
Variance2953941.285
MonotonicityNot monotonic
2021-12-24T00:22:24.935211image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
178501
 
< 0.1%
175881
 
< 0.1%
149051
 
< 0.1%
161031
 
< 0.1%
146261
 
< 0.1%
148681
 
< 0.1%
182461
 
< 0.1%
171151
 
< 0.1%
166111
 
< 0.1%
159121
 
< 0.1%
Other values (2960)2960
99.7%
ValueCountFrequency (%)
123471
< 0.1%
123481
< 0.1%
123521
< 0.1%
123561
< 0.1%
123581
< 0.1%
123591
< 0.1%
123601
< 0.1%
123621
< 0.1%
123641
< 0.1%
123701
< 0.1%
ValueCountFrequency (%)
182871
< 0.1%
182831
< 0.1%
182821
< 0.1%
182771
< 0.1%
182761
< 0.1%
182741
< 0.1%
182731
< 0.1%
182721
< 0.1%
182701
< 0.1%
182691
< 0.1%

gross_revenue
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct2955
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2748.786333
Minimum6.2
Maximum279138.02
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2021-12-24T00:22:25.200221image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/

Quantile statistics

Minimum6.2
5-th percentile229.8075
Q1571.02
median1088.53
Q32307.675
95-th percentile7217.565
Maximum279138.02
Range279131.82
Interquartile range (IQR)1736.655

Descriptive statistics

Standard deviation10578.88154
Coefficient of variation (CV)3.848564516
Kurtosis354.0627168
Mean2748.786333
Median Absolute Deviation (MAD)673.06
Skewness16.7803378
Sum8163895.41
Variance111912734.7
MonotonicityNot monotonic
2021-12-24T00:22:25.507805image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
178.962
 
0.1%
533.332
 
0.1%
889.932
 
0.1%
2053.022
 
0.1%
745.062
 
0.1%
2092.322
 
0.1%
379.652
 
0.1%
731.92
 
0.1%
1353.742
 
0.1%
3312
 
0.1%
Other values (2945)2950
99.3%
ValueCountFrequency (%)
6.21
< 0.1%
13.31
< 0.1%
151
< 0.1%
36.561
< 0.1%
451
< 0.1%
521
< 0.1%
52.21
< 0.1%
52.21
< 0.1%
62.431
< 0.1%
68.841
< 0.1%
ValueCountFrequency (%)
279138.021
< 0.1%
259657.31
< 0.1%
194550.791
< 0.1%
168472.51
< 0.1%
140450.721
< 0.1%
124564.531
< 0.1%
117379.631
< 0.1%
91062.381
< 0.1%
72882.091
< 0.1%
66653.561
< 0.1%

recency_days
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct272
Distinct (%)9.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean64.31346801
Minimum0
Maximum373
Zeros34
Zeros (%)1.1%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2021-12-24T00:22:25.804407image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2
Q111
median31
Q381
95-th percentile242
Maximum373
Range373
Interquartile range (IQR)70

Descriptive statistics

Standard deviation77.7564254
Coefficient of variation (CV)1.20902243
Kurtosis2.774045758
Mean64.31346801
Median Absolute Deviation (MAD)26
Skewness1.797124381
Sum191011
Variance6046.061691
MonotonicityNot monotonic
2021-12-24T00:22:26.130403image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
199
 
3.3%
487
 
2.9%
285
 
2.9%
385
 
2.9%
876
 
2.6%
1067
 
2.3%
966
 
2.2%
766
 
2.2%
1764
 
2.2%
1655
 
1.9%
Other values (262)2220
74.7%
ValueCountFrequency (%)
034
 
1.1%
199
3.3%
285
2.9%
385
2.9%
487
2.9%
543
1.4%
766
2.2%
876
2.6%
966
2.2%
1067
2.3%
ValueCountFrequency (%)
3732
0.1%
3724
0.1%
3711
 
< 0.1%
3681
 
< 0.1%
3664
0.1%
3652
0.1%
3641
 
< 0.1%
3601
 
< 0.1%
3591
 
< 0.1%
3584
0.1%

qtde_invoices
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct56
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.722222222
Minimum1
Maximum206
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2021-12-24T00:22:26.436517image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median4
Q36
95-th percentile17
Maximum206
Range205
Interquartile range (IQR)4

Descriptive statistics

Standard deviation8.855180674
Coefficient of variation (CV)1.547507302
Kurtosis190.8917484
Mean5.722222222
Median Absolute Deviation (MAD)2
Skewness10.7684025
Sum16995
Variance78.41422477
MonotonicityNot monotonic
2021-12-24T00:22:26.902744image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2785
26.4%
3500
16.8%
4393
13.2%
5237
 
8.0%
1190
 
6.4%
6173
 
5.8%
7138
 
4.6%
898
 
3.3%
969
 
2.3%
1055
 
1.9%
Other values (46)332
11.2%
ValueCountFrequency (%)
1190
 
6.4%
2785
26.4%
3500
16.8%
4393
13.2%
5237
 
8.0%
6173
 
5.8%
7138
 
4.6%
898
 
3.3%
969
 
2.3%
1055
 
1.9%
ValueCountFrequency (%)
2061
< 0.1%
1991
< 0.1%
1241
< 0.1%
971
< 0.1%
912
0.1%
861
< 0.1%
721
< 0.1%
622
0.1%
601
< 0.1%
571
< 0.1%

qtde_items
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct1671
Distinct (%)56.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1608.475758
Minimum1
Maximum196844
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2021-12-24T00:22:27.235508image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile102.45
Q1296.25
median640
Q31400.5
95-th percentile4407.2
Maximum196844
Range196843
Interquartile range (IQR)1104.25

Descriptive statistics

Standard deviation5886.622254
Coefficient of variation (CV)3.659751927
Kurtosis466.1489505
Mean1608.475758
Median Absolute Deviation (MAD)421
Skewness17.86145938
Sum4777173
Variance34652321.56
MonotonicityNot monotonic
2021-12-24T00:22:27.597896image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
31011
 
0.4%
1509
 
0.3%
889
 
0.3%
2468
 
0.3%
2888
 
0.3%
2728
 
0.3%
848
 
0.3%
2608
 
0.3%
1147
 
0.2%
5167
 
0.2%
Other values (1661)2887
97.2%
ValueCountFrequency (%)
11
< 0.1%
22
0.1%
122
0.1%
161
< 0.1%
171
< 0.1%
181
< 0.1%
191
< 0.1%
201
< 0.1%
231
< 0.1%
251
< 0.1%
ValueCountFrequency (%)
1968441
< 0.1%
809971
< 0.1%
802631
< 0.1%
773731
< 0.1%
699931
< 0.1%
645491
< 0.1%
641241
< 0.1%
633121
< 0.1%
583431
< 0.1%
578851
< 0.1%

qtde_products
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct468
Distinct (%)15.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean122.7020202
Minimum1
Maximum7838
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2021-12-24T00:22:27.933628image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile9
Q129
median67
Q3135
95-th percentile382
Maximum7838
Range7837
Interquartile range (IQR)106

Descriptive statistics

Standard deviation269.8536468
Coefficient of variation (CV)2.199260015
Kurtosis354.9723233
Mean122.7020202
Median Absolute Deviation (MAD)44
Skewness15.71004775
Sum364425
Variance72820.99067
MonotonicityNot monotonic
2021-12-24T00:22:28.195323image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2843
 
1.4%
2037
 
1.2%
3535
 
1.2%
2935
 
1.2%
1934
 
1.1%
1533
 
1.1%
1132
 
1.1%
2631
 
1.0%
2730
 
1.0%
2530
 
1.0%
Other values (458)2630
88.6%
ValueCountFrequency (%)
16
 
0.2%
214
0.5%
316
0.5%
417
0.6%
526
0.9%
629
1.0%
718
0.6%
819
0.6%
926
0.9%
1028
0.9%
ValueCountFrequency (%)
78381
< 0.1%
56731
< 0.1%
50951
< 0.1%
45801
< 0.1%
26981
< 0.1%
23791
< 0.1%
20601
< 0.1%
18181
< 0.1%
16731
< 0.1%
16371
< 0.1%

avg_ticket
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct2967
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean51.88713523
Minimum2.150588235
Maximum56157.5
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2021-12-24T00:22:28.488721image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/

Quantile statistics

Minimum2.150588235
5-th percentile4.917434212
Q113.11982258
median17.96548505
Q324.98612169
95-th percentile90.49558333
Maximum56157.5
Range56155.34941
Interquartile range (IQR)11.86629911

Descriptive statistics

Standard deviation1036.759927
Coefficient of variation (CV)19.98105932
Kurtosis2891.680514
Mean51.88713523
Median Absolute Deviation (MAD)5.975979236
Skewness53.45321988
Sum154104.7916
Variance1074871.146
MonotonicityNot monotonic
2021-12-24T00:22:28.798374image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
152
 
0.1%
4.1622
 
0.1%
14.478333332
 
0.1%
18.152222221
 
< 0.1%
31.54080461
 
< 0.1%
29.784166671
 
< 0.1%
22.87926231
 
< 0.1%
20.511041671
 
< 0.1%
149.0251
 
< 0.1%
21.474358971
 
< 0.1%
Other values (2957)2957
99.6%
ValueCountFrequency (%)
2.1505882351
< 0.1%
2.43251
< 0.1%
2.4623711341
< 0.1%
2.5112413791
< 0.1%
2.5153333331
< 0.1%
2.651
< 0.1%
2.6569318181
< 0.1%
2.7075982531
< 0.1%
2.7606215721
< 0.1%
2.7704641911
< 0.1%
ValueCountFrequency (%)
56157.51
< 0.1%
4453.431
< 0.1%
3202.921
< 0.1%
1687.21
< 0.1%
952.98751
< 0.1%
872.131
< 0.1%
841.02144931
< 0.1%
651.16833331
< 0.1%
6401
< 0.1%
624.41
< 0.1%

avg_recency_days
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct1258
Distinct (%)42.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean67.33548719
Minimum1
Maximum366
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2021-12-24T00:22:29.217185image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile8
Q125.92445055
median48.26785714
Q385.33333333
95-th percentile201
Maximum366
Range365
Interquartile range (IQR)59.40888278

Descriptive statistics

Standard deviation63.53819113
Coefficient of variation (CV)0.9436063178
Kurtosis4.889533464
Mean67.33548719
Median Absolute Deviation (MAD)26.26785714
Skewness2.063271059
Sum199986.397
Variance4037.101731
MonotonicityNot monotonic
2021-12-24T00:22:29.559213image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1425
 
0.8%
422
 
0.7%
7021
 
0.7%
720
 
0.7%
3519
 
0.6%
4918
 
0.6%
4617
 
0.6%
2117
 
0.6%
1117
 
0.6%
2816
 
0.5%
Other values (1248)2778
93.5%
ValueCountFrequency (%)
116
0.5%
1.51
 
< 0.1%
213
0.4%
2.51
 
< 0.1%
2.6013986011
 
< 0.1%
315
0.5%
3.3214285711
 
< 0.1%
3.3303571431
 
< 0.1%
3.52
 
0.1%
422
0.7%
ValueCountFrequency (%)
3661
 
< 0.1%
3651
 
< 0.1%
3631
 
< 0.1%
3621
 
< 0.1%
3572
0.1%
3561
 
< 0.1%
3552
0.1%
3521
 
< 0.1%
3512
0.1%
3503
0.1%

frequency
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct1225
Distinct (%)41.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.1137705987
Minimum0.005449591281
Maximum17
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2021-12-24T00:22:29.863655image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/

Quantile statistics

Minimum0.005449591281
5-th percentile0.008894823607
Q10.01633986928
median0.02589835169
Q30.04944256325
95-th percentile1
Maximum17
Range16.99455041
Interquartile range (IQR)0.03310269397

Descriptive statistics

Standard deviation0.4080901054
Coefficient of variation (CV)3.58695577
Kurtosis989.6800284
Mean0.1137705987
Median Absolute Deviation (MAD)0.0121968864
Skewness24.88439605
Sum337.8986781
Variance0.1665375341
MonotonicityNot monotonic
2021-12-24T00:22:30.251157image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1198
 
6.7%
0.062518
 
0.6%
0.0277777777817
 
0.6%
0.0238095238116
 
0.5%
0.0344827586215
 
0.5%
0.0909090909115
 
0.5%
0.0833333333315
 
0.5%
0.0294117647114
 
0.5%
0.0357142857113
 
0.4%
0.0769230769213
 
0.4%
Other values (1215)2636
88.8%
ValueCountFrequency (%)
0.0054495912811
 
< 0.1%
0.0054644808741
 
< 0.1%
0.0054794520551
 
< 0.1%
0.0054945054951
 
< 0.1%
0.0055865921792
0.1%
0.0056022408961
 
< 0.1%
0.0056179775282
0.1%
0.005665722381
 
< 0.1%
0.0056818181822
0.1%
0.0056980056983
0.1%
ValueCountFrequency (%)
171
 
< 0.1%
31
 
< 0.1%
26
 
0.2%
1.1428571431
 
< 0.1%
1198
6.7%
0.751
 
< 0.1%
0.66666666673
 
0.1%
0.5508021391
 
< 0.1%
0.53351206431
 
< 0.1%
0.53
 
0.1%

qtde_returns
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct214
Distinct (%)7.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean62.13670034
Minimum0
Maximum80995
Zeros1481
Zeros (%)49.9%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2021-12-24T00:22:30.624924image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q39
95-th percentile100.55
Maximum80995
Range80995
Interquartile range (IQR)9

Descriptive statistics

Standard deviation1512.241801
Coefficient of variation (CV)24.33733676
Kurtosis2766.459377
Mean62.13670034
Median Absolute Deviation (MAD)1
Skewness51.80645659
Sum184546
Variance2286875.265
MonotonicityNot monotonic
2021-12-24T00:22:31.044692image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
01481
49.9%
1164
 
5.5%
2149
 
5.0%
3105
 
3.5%
489
 
3.0%
678
 
2.6%
561
 
2.1%
1251
 
1.7%
843
 
1.4%
743
 
1.4%
Other values (204)706
23.8%
ValueCountFrequency (%)
01481
49.9%
1164
 
5.5%
2149
 
5.0%
3105
 
3.5%
489
 
3.0%
561
 
2.1%
678
 
2.6%
743
 
1.4%
843
 
1.4%
941
 
1.4%
ValueCountFrequency (%)
809951
< 0.1%
90141
< 0.1%
80041
< 0.1%
44271
< 0.1%
37681
< 0.1%
33321
< 0.1%
28781
< 0.1%
20221
< 0.1%
20121
< 0.1%
17761
< 0.1%

avg_basket_size
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct1980
Distinct (%)66.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean249.7846461
Minimum1
Maximum40498.5
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2021-12-24T00:22:31.364210image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile44
Q1103.2625
median172.2916667
Q3281.6442308
95-th percentile600
Maximum40498.5
Range40497.5
Interquartile range (IQR)178.3817308

Descriptive statistics

Standard deviation791.4234658
Coefficient of variation (CV)3.168423192
Kurtosis2256.28608
Mean249.7846461
Median Absolute Deviation (MAD)83.04166667
Skewness44.68007213
Sum741860.399
Variance626351.1022
MonotonicityNot monotonic
2021-12-24T00:22:31.792544image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
10011
 
0.4%
11410
 
0.3%
869
 
0.3%
739
 
0.3%
829
 
0.3%
608
 
0.3%
888
 
0.3%
1368
 
0.3%
758
 
0.3%
1297
 
0.2%
Other values (1970)2883
97.1%
ValueCountFrequency (%)
12
0.1%
21
< 0.1%
3.3333333331
< 0.1%
5.3333333331
< 0.1%
5.6666666671
< 0.1%
6.1428571431
< 0.1%
7.51
< 0.1%
91
< 0.1%
9.51
< 0.1%
111
< 0.1%
ValueCountFrequency (%)
40498.51
< 0.1%
6009.3333331
< 0.1%
42821
< 0.1%
39061
< 0.1%
3868.651
< 0.1%
28801
< 0.1%
28011
< 0.1%
2733.9444441
< 0.1%
2518.7692311
< 0.1%
2160.3333331
< 0.1%

avg_unique_basket_size
Real number (ℝ≥0)

HIGH CORRELATION

Distinct906
Distinct (%)30.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17.48420374
Minimum0.2
Maximum259
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2021-12-24T00:22:32.130030image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/

Quantile statistics

Minimum0.2
5-th percentile2
Q17.666666667
median13.6
Q322.10714286
95-th percentile46
Maximum259
Range258.8
Interquartile range (IQR)14.44047619

Descriptive statistics

Standard deviation15.45771808
Coefficient of variation (CV)0.8840961992
Kurtosis29.32853391
Mean17.48420374
Median Absolute Deviation (MAD)6.6
Skewness3.436505023
Sum51928.08512
Variance238.9410481
MonotonicityNot monotonic
2021-12-24T00:22:32.459979image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1342
 
1.4%
941
 
1.4%
839
 
1.3%
1639
 
1.3%
1438
 
1.3%
1738
 
1.3%
536
 
1.2%
1136
 
1.2%
736
 
1.2%
1535
 
1.2%
Other values (896)2590
87.2%
ValueCountFrequency (%)
0.21
 
< 0.1%
0.253
 
0.1%
0.33333333336
0.2%
0.41
 
< 0.1%
0.40909090911
 
< 0.1%
0.512
0.4%
0.54545454551
 
< 0.1%
0.55555555561
 
< 0.1%
0.57142857141
 
< 0.1%
0.61764705881
 
< 0.1%
ValueCountFrequency (%)
2591
< 0.1%
1771
< 0.1%
1481
< 0.1%
1271
< 0.1%
1051
< 0.1%
1041
< 0.1%
1011
< 0.1%
981
< 0.1%
95.51
< 0.1%
94.333333331
< 0.1%

Interactions

2021-12-24T00:22:19.068207image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:35.287013image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:38.905156image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:42.665025image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:46.273602image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:50.009727image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:53.334768image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:57.292722image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:00.968293image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:04.580988image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:08.108102image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:11.623565image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:15.476192image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:19.300793image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:35.582930image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:39.194860image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:42.929379image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:46.554150image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:50.276069image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:53.577234image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:57.591751image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:01.182490image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:04.842416image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:08.384810image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:11.874970image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:15.768042image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:19.592096image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:35.806588image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:39.458889image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:43.167235image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:46.840640image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:50.521066image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:53.811025image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:57.886844image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:01.422866image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:05.109207image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:08.624455image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:12.413885image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:16.037233image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:20.111895image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:36.105978image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:39.718963image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:43.404544image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:47.139312image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:50.719105image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:54.101520image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:58.118492image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:01.679009image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:05.376775image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:08.849924image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:12.658864image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:16.265127image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:20.386903image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:36.424659image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:39.982025image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:43.713314image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:47.428361image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:50.981564image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:54.402459image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:58.340664image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:01.982965image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:05.630484image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:09.161009image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:12.960834image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:16.555047image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:20.615321image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:36.702129image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:40.188528image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:43.985842image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:47.644162image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:51.246616image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:54.683312image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:58.631413image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:02.264687image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:05.858458image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:09.431163image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:13.181975image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:16.829103image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:20.834404image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:37.017469image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:40.712266image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:44.311145image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:47.872066image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:51.523725image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:54.998714image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:58.943865image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:02.525226image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:06.177174image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:09.720877image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:13.445842image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:17.138668image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:21.130442image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:37.268519image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:41.001899image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:44.566151image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:48.189140image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:51.791852image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:55.237935image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:59.232656image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:02.754459image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:06.468985image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:10.006377image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:13.741001image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:17.436166image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:21.398273image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:37.517071image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:41.276634image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:44.771367image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:48.470081image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:52.039918image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:55.543684image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:59.548147image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:03.005574image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:06.745940image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:10.225688image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:14.048209image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:17.665268image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:21.671779image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:37.852685image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:41.546555image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:45.077267image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:48.978951image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:52.273849image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:55.837200image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:59.796430image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:03.294589image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:07.013318image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:10.536604image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:14.343758image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:17.924308image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:21.929691image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:38.133259image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:41.783981image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:45.412205image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:49.192281image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:52.503632image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:56.137595image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:00.122797image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:03.558562image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:07.252831image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:10.839149image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:14.607437image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:18.204539image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:22.181092image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:38.413774image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:42.091985image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:45.728575image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:49.442782image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:52.787414image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:56.711601image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:00.415025image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:03.839340image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:07.565475image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:11.121964image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:14.855304image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:18.480749image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:22.445126image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:38.666542image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:42.374474image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:46.044808image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:49.726059image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:53.056694image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:21:56.976338image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:00.700860image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:04.112764image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:07.850341image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:11.394801image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:15.193707image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
2021-12-24T00:22:18.784540image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/

Correlations

2021-12-24T00:22:32.891093image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
2021-12-24T00:22:33.294585image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
2021-12-24T00:22:33.796929image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
2021-12-24T00:22:34.173711image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

2021-12-24T00:22:22.920447image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
A simple visualization of nullity by column.
2021-12-24T00:22:23.526173image/svg+xmlMatplotlib v3.5.1, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

First rows

df_indexcustomer_idgross_revenuerecency_daysqtde_invoicesqtde_itemsqtde_productsavg_ticketavg_recency_daysfrequencyqtde_returnsavg_basket_sizeavg_unique_basket_size
00178505391.21372.034.01733.0297.018.15222235.50000017.00000040.050.9705880.617647
11130473232.5956.09.01390.0171.018.90403527.2500000.02830235.0154.44444411.666667
22125836705.382.015.05028.0232.028.90250023.1875000.04032350.0335.2000007.600000
3313748948.2595.05.0439.028.033.86607192.6666670.0179210.087.8000004.800000
4415100876.00333.03.080.03.0292.0000008.6000000.07317122.026.6666670.333333
55152914623.3025.014.02102.0102.045.32647123.2000000.04011529.0150.1428574.357143
66146885630.877.021.03621.0327.017.21978618.3000000.057221399.0172.4285717.047619
77178095411.9116.012.02057.061.088.71983635.7000000.03352041.0171.4166673.833333
881531160767.900.091.038194.02379.025.5434644.1444440.243316474.0419.7142866.230769
99160982005.6387.07.0613.067.029.93477647.6666670.0243900.087.5714294.857143

Last rows

df_indexcustomer_idgross_revenuerecency_daysqtde_invoicesqtde_itemsqtde_productsavg_ticketavg_recency_daysfrequencyqtde_returnsavg_basket_sizeavg_unique_basket_size
29605628177271060.2515.01.0645.066.016.0643946.01.0000006.0645.00000066.000000
2961563817232421.522.02.0203.036.011.70888912.00.1538460.0101.50000015.000000
2962563917468137.0010.02.0116.05.027.4000004.00.4000000.058.0000002.500000
2963565013596697.045.02.0406.0166.04.1990367.00.2500000.0203.00000066.500000
29645656148931237.859.02.0799.073.016.9568492.00.6666670.0399.50000036.000000
2965566012479473.2011.01.0382.030.015.7733334.01.00000034.0382.00000030.000000
2966568114126706.137.03.0508.015.047.0753333.00.75000050.0169.3333334.666667
29675687135211092.391.03.0733.0435.02.5112414.50.3000000.0244.333333104.000000
2968569715060301.848.04.0262.0120.02.5153331.02.0000000.065.50000020.000000
2969571612558269.967.01.0196.011.024.5418186.01.000000196.0196.00000011.000000